Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Sales CountryRegionCurrency (table)
Print
RSS
Modified on 2011/08/27 11:18
by
wikibot
Categorized as
Uncategorized
Person CountryRegion (table)
Sales (schema)
Sales Currency (table)
Person CountryRegion (table)
Sales (schema)
Sales Currency (table)
»
Sales CountryRegionCurrency (table)
[X]
»
Sales CountryRegionCurrency (table)
wikibot
¶
Table
Sales.CountryRegionCurrency
Description
Cross-reference table mapping ISO currency codes to a country or region.
Columns
¶
Column
Data Type
Nullable
Default
Description
CountryRegionCode
nvarchar(3)
not null
ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode.
CurrencyCode
nchar(3)
not null
ISO standard currency code. Foreign key to Currency.CurrencyCode.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
CountryRegionCode, CurrencyCode
Indexes
¶
Index
Type
Columns
IX_CountryRegionCurrency_CurrencyCode
CurrencyCode
Foreign Keys
¶
Relation
Column
Referenced Column
Person.CountryRegion
CountryRegionCode
CountryRegionCode
Sales.Currency
CurrencyCode
CurrencyCode
References
¶
Dependency Type
Object Type
Referenced Object
Schema
Schema
Sales
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.